| Course: |
Dynamic Web Server-Side Technologies Crash Course using PHP/MySQL/Apache
with Computer Lab |
| Date: |
Two consecutive Saturdays, April 1 and 8, 2006, 9:00 AM - 5:00 PM
|
| CourseId: |
UWEB2 |
| Location: |
Qualware Offices, Dennis Drive, Burlington, MA |
| Instructor: |
Jeffrey Goldberg, Qualware Instructional
Services |
| Provided Text: |
ISBN: 1893115518
After clicking, see book on last line.
If not found, use Alt
|
Course of identical content as IEEE sponsored course of November 2005 but adding hands-on lab exercises.
Class Description:
Dynamic Web Server-Side Technologies Overview. This is an newly created, fast paced, detailed introduction to everything you need to know about creating and hosting dynamic, interactive web pages, and understanding how they operate.
This mini-course will start with a quick teach/review of HTML language basics including tables, frames and forms, cascading style sheets and XML, and then proceed to a discussion of the client-server three tier networks. In these systems, browsers talk to web servers which in turn request data from in-house SQL (Structured Query Language) database servers. A web server running PHP/JSP/ASP is then responsible for formatting and presenting this data as dynamic web pages.
An introduction to PHP and SQL will then follow. PHP is a widely-used, Linux/UNIX based, general-purpose modern server-side scripting language that is especially suited for Web development and can be embedded into HTML documents. It shares many of the modern constructs found in C/C++, Java, and Perl languages.
This course will also focus on using SQL within PHP HTML documents running under Apache. The course will wrap up with tips about server configurations, security, and a demonstration of how easy it is to include the contents of a SQL database within dynamically generated web pages.
Prerequisite:
No prior experience is required, but attendees would benefit from prior programming experience or knowledge of a modern-day structured programming language. Familiarity with Web browsing, Windows and/or UNIX and UNIX VI editor (for lab exercises) would also be helpful.
Targeted for:
Individuals who would like to gain insight into the bigger picture of how multi-tier dynamic web systems operate. The course will start by explaining the fundamentals upon which all web documents and web services are built, with special focus on using server side programming in PHP and SQL that are used to make web sites interactive. The material in this courses is appropriate for individuals maintaining pages on a provider’s server as well as those interested in setting up their own personal or company information server.
This class is structured to be as interactive as possible by making use of live demonstrations that emphasis the concepts taught in the class, and personal laptop computers can be brought to class for experimentation.
Handouts:
Copies of the course outline slides will be provided along with
relevant handouts when appropriate.
Content Outline Summary:
PRELIMINARY AGENDA:
Three sessions will be covered per day.
- Morning Session 1- Introduction to HTML
- Introduction to HTML tags
- Code example of a homepage
- Using head, meta, body, breaks, image and anchor tags
- Common (list, escape, formatting) HTML tags
- Additional HTML tags including details on:
- Using fonts, colors, transitions
- Using lists, tables, borders
- Using links, anchors, mailto
- Using images and gifs
- Advanced HTML:
- Forms and input objects
- Frames, windows and targets
- Introduction to scripts
- Example registration form
- Basic form HTML tags
- Advanced form HTML tags
Morning/Afternoon Session 2- XML and Cascading Style Sheets
- Cascading Style Sheets
- Style properties
- Style types (inline, global, linked)
- How and why you implement them
- Introduction to XML
- Basic XML
- Clients reading XML documents as source of data
- Overview of Capabilities of Java Script without programming details
Afternoon Session 3- Dynamic Web and Submitting Data to a Server
- Submitting Data to a Server Concepts
- Client Browser/Web Server Model and Protocols
- Understanding and Using Uniform Resource Locators (URL)*
- Server Side Includes, HTML Forms with CGI
- Basic Data Passing Methods
- Gets vs Post, Actions, Encoding, etc
- Workload Division, Interactive Web Methods
- Home Page Installation
- Keeping Track of Your Web Page Visitors
- Sample PHP Script
Morning Session 4- Introduction to Server Side PHP
- PHP and Example Script
- How PHP Differs and What It Can Do
- Features, Parsing and Advanced Escaping
- Variables and Primitive Data Types
- Strings and Quoting Options
- Limited Casting
- PHP Arrays
- Math Operator and Assignment Precedence
- Comparison and Logical Operators
- Conditional Branching, Decision Statements and Looping Constructs
- User Defined Functions, Scope and Lifetime
- Predefined Variables and Connecting to the Web Server
- Simple PHP Form*
Morning/Afternoon Session 5- Database Connectivity using MySQL
- Database Models
- Introduction to MySQL Database Functionality
- DB Terminology and Constraints, Supported Data Types
- Setting Up MySQL Service
- SQL Language Components
- Controlling MySQL Database Access
- MySQL Command Line Interface
- Performing a Query with Select*
- SQL Aggregate and Scalar Functions
- Creating and Updating Tables, Interactive Demo of pets.php
- Proprietary Show Command Syntax
Afternoon Session 6- Web Access of Databases, Server Customization and Control
- Programmatic Access of MySQL Database Connectivity
- Forms that insert information into the database tables.
- Apache PHP MySQL, Browser & Network Consideration
- Some Global Security and Access Control* (httpd.conf, php.ini)
- Apache Access Control of user directories with .htaccess
- PHP track_vars feature enabled makes $HTTP_XXX_VARS available.
- PHP's Super Global Varables*
- Overview of Session Management and Browser Considerations
- Hidden Fields, Cookies to retain state
- Sessions, Browser Caching
- wrap-up.
For more info: email to jeffg@qualware.com
Add "not spam" to subject field.
Lecturer's biography:
An honor graduate of Tufts University, Jeffrey M. Goldberg
has served the engineering and academic community in various roles
from principal design engineer/project leader to senior consultant and
trainer at companies such as Hewlett Packard, Siemens,
Picturetel, 3Com, IBM, NMS, FST, IEEE, and EMC.
Mr. Goldberg is a long-time innovative user of UNIX and Internet services.
He currently develops and delivers public seminars and customized
corporate training classes along with very flexible scheduling,
to avoid project disruption, in the fields of IT operations,
operating system and computer languages. Specialties include
UNIX Fundamentals, Perl and Shell Scripting, C/C++ and Java,
Linux/Solaris/ UNIX System Administration and TCP/IP Networking,
Web Technologies such as Visual Basic, Delphi/Pascal, JavaScript,
PHP Apache /Tomcat, JSP/Servlets and SQL Database Access,
Computer and Network Security.
As a part time faculty of Worcester Polytechnic Institute and
Boston University, Mr. Goldberg is continually adding
new cutting-edge technology to his curriculum, and accepts
requests for customized on-site corporate training classes and tutoring.
For more information, please contact Mr. Goldberg at 781-229-1530 ext. 2
(Qualware), e-mail to
training2010@qualware.com
or visit
www.Qualware.com.
Besides operating Qualware Instructional Services, Mr. Goldberg is
also a principal of Qualware Consulting Group,
which performs a wide range of consulting services.
For more information, visit
http://www.qualware.com/qualware.
Copyright 2003-2010 Qualware Instructional Services and
Jeffrey Goldberg.
Course Fee Schedule:
REGISTRATION RECEIVED BY
Mar 24, 2006 |
REGISTRATION RECEIVED AFTER
Mar 24, 2006 |
|
$399 Special (normally $446) |
$563 |
Option exists to take one session only at a reduced cost.
|